SUPPORT / SAMPLES & SAS NOTES
Problem Note 55137: Estimation or model analysis might fail with "ERROR: TKTException code = 2 (Floating point divide by zero)"
 |  |  |  |  |
In the SAS® Revenue Optimization Suite, estimation or model analysis might fail with the following error in the MerchIntelGridSvr.log file:
2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - ERROR: TKTException code = 2 (Floating point divide by zero) 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #4 0x00007f9d7735f9cc in tkmi_exception_handler (thread=0x1574, ctxt=0x7f9d2982e58c, code=TKTE_UnknownException) at /sas/dev/mva-f4ro52/di/src/tkmi_exception.c:88 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #5 0x00007f9d82d06196 in bktExcept () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #6 0x00007f9d82d098a5 in bkt_fpe () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #7 0x00007f9d82d06764 in bkt_signal_handler () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #8 <signal handler called> 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #9 0x00007f9d77668c4d in log.L () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmi.so 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #10 0x00007f9d774083ab in reg_process_model_data_row (p_row_num=0x1, reg_md_frame=0x7f9d7782bd00, buffer=0x0, expdecay=0, reg_prod=0xffffe00000000000, reg_geo=0x7f9d2982ff34, md=..., reg_sales_var_type=REG_SALES_VOLUME, lcp_curve_type=LCP_GAMMA, ps_total_length=0, hd_total_length=33, reg_holiday=0, baseline_offset=0, add_ps_buf=0x0, reg_model_spec=0x7f9c4e8c7240, ts_mgr=0x7f9c5b857a30, re 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - 20150130:02.49.39.76: g_manager=0x7f9ca8460410, def_est=0x7f9c60adef50, num_obs_index_hash=0x7f9c414c4db0, data_tsf_st=0x7f9d29830090, num_deleted=0x7f9d2982ff34, m_effects=0x7f9ca8460600) at /sas/dev/mva-f4ro52/di/src/reg_data_tsf.c:865 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #11 0x00007f9d774055f4 in reg_data_transform (reg_manager=0x1) at /sas/dev/mva-f4ro52/di/src/reg_data_tsf.c:380 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #12 0x00007f9d774039ed in reg_data_transform_run (this=0x1) at /sas/dev/mva-f4ro52/di/src/reg_run.c:75 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #13 0x00007f9d774034d3 in reg_manager_run (this=0x1) at /sas/dev/mva-f4ro52/di/src/reg_manager.c:350 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #14 0x00007f9d77366b34 in process_reg (context=0x1) at /sas/dev/mva-f4ro52/di/src/est_service.c:1639 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #15 0x00007f9d7734b748 in logic_fn (ctxt=0x7f9d76935600, req=0x7f9c42a96fa0, thread=0x7f9d68c77990, cb=0x7f9d78675c88) at /sas/dev/mva-f4ro52/di/src/job_manager.c:1281 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #16 0x00007f9d7977ad0b in basicPuddleMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkepdl.so 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #17 0x00007f9d82d049a6 in sktMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #18 0x00007f9d82d05ffb in bkt 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - 20150130:02.49.39.76: Main () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #19 0x00000035f08079d1 in start_thread () from /lib64/libpthread.so.0 2015-01-30 02:49:51,714 [pool-5-thread-2] DEBUG - #20 0x00000035f00e8b6d in clone () from /lib64/libc.so.6
This error is generated when you have fluctuating hedonic prices and you have set the HEDONIC_VOL_TSF model specification to 1.
The workaround for this issue is to set the HEDONIC_VOL_TSF model specification to 0, which is recommendation when you have fluctuating hedonic prices.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Retail Forecasting | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||